﻿CREATE TABLE [dbo].[UDS_Team] (
    [Team_ID]          int          NOT NULL identity(1, 1),
    [Super_Team_ID]    int          NULL,
    [Team_Name]        nvarchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
    [Team_Description] nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL,

    CONSTRAINT [PK_UDS_Team] PRIMARY KEY CLUSTERED ([Team_ID] asc),
    CONSTRAINT [FK_UDS_Team_UDS_Team] FOREIGN KEY ([Super_Team_ID]) REFERENCES [dbo].[UDS_Team] ([Team_ID])
);
GO
